﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSetDB" targetNamespace="http://tempuri.org/DataSetDB.xsd" xmlns:mstns="http://tempuri.org/DataSetDB.xsd" xmlns="http://tempuri.org/DataSetDB.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="DatabaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DatabaseConnectionString (Web.config)" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.DatabaseConnectionString.ConnectionString" Provider="System.Data.OleDb" />
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="Database2003ConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="Database2003ConnectionString (Web.config)" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.Database2003ConnectionString.ConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="USERSTableAdapter" GeneratorDataComponentClassName="USERSTableAdapter" Name="USERS" UserDataComponentName="USERSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Web.config)" DbObjectName="USERS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `USERS` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `USERS` (`LOGINNAME`, `LOGINPWD`, `USERNAME`, `AREA`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LOGINNAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LOGINNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LOGINPWD" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LOGINPWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="USERNAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="USERNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AREA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, LOGINNAME, LOGINPWD, USERNAME, AREA FROM USERS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `USERS` SET `LOGINNAME` = ?, `LOGINPWD` = ?, `USERNAME` = ?, `AREA` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LOGINNAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LOGINNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LOGINPWD" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LOGINPWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="USERNAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="USERNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AREA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="LOGINNAME" DataSetColumn="LOGINNAME" />
              <Mapping SourceColumn="LOGINPWD" DataSetColumn="LOGINPWD" />
              <Mapping SourceColumn="USERNAME" DataSetColumn="USERNAME" />
              <Mapping SourceColumn="AREA" DataSetColumn="AREA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseConnectionString (Web.config)" DbObjectName="USERS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserNamePwd" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserNamePwd" GeneratorSourceName="FillByUserNamePwd" GetMethodModifier="Public" GetMethodName="GetDataByUserNamePwd" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserNamePwd" UserSourceName="FillByUserNamePwd">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, LOGINNAME, LOGINPWD, USERNAME, AREA FROM USERS
WHERE LOGINNAME=? AND  LOGINPWD=?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LOGINNAME" DataSourceName="USERS" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LOGINNAME" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LOGINNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="LOGINPWD" DataSourceName="USERS" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LOGINPWD" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LOGINPWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PERSIONSTableAdapter" GeneratorDataComponentClassName="PERSIONSTableAdapter" Name="PERSIONS" UserDataComponentName="PERSIONSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Web.config)" DbObjectName="PERSIONS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `PERSIONS` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `PERSIONS` (`USERNAME`, `QQ`, `PHONE`, `ADDRESS`, `PERSONSCOUNT`, `AREA`, `STATUS`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="USERNAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="USERNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="QQ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="QQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PHONE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ADDRESS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ADDRESS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PERSONSCOUNT" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PERSONSCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AREA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="STATUS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, USERNAME, QQ, PHONE, ADDRESS, PERSONSCOUNT,AREA,STATUS FROM PERSIONS
ORDER BY STATUS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `PERSIONS` SET `USERNAME` = ?, `QQ` = ?, `PHONE` = ?, `ADDRESS` = ?, `PERSONSCOUNT` = ?, `AREA` = ?, `STATUS` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="USERNAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="USERNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="QQ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="QQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PHONE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ADDRESS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ADDRESS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PERSONSCOUNT" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PERSONSCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AREA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="STATUS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="USERNAME" DataSetColumn="USERNAME" />
              <Mapping SourceColumn="QQ" DataSetColumn="QQ" />
              <Mapping SourceColumn="PHONE" DataSetColumn="PHONE" />
              <Mapping SourceColumn="ADDRESS" DataSetColumn="ADDRESS" />
              <Mapping SourceColumn="PERSONSCOUNT" DataSetColumn="PERSONSCOUNT" />
              <Mapping SourceColumn="AREA" DataSetColumn="AREA" />
              <Mapping SourceColumn="STATUS" DataSetColumn="STATUS" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseConnectionString (Web.config)" DbObjectName="PERSIONS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByAREA" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByAREA" GeneratorSourceName="FillByAREA" GetMethodModifier="Public" GetMethodName="GetDataByAREA" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByAREA" UserSourceName="FillByAREA">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ADDRESS, AREA, ID, PERSONSCOUNT, PHONE, QQ, STATUS, USERNAME FROM PERSIONS WHERE (AREA = ?)  ORDER BY STATUS</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="AREA" DataSourceName="PERSIONS" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="AREA" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Web.config)" DbObjectName="PERSIONS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPhone" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPhone" GeneratorSourceName="FillByPhone" GetMethodModifier="Public" GetMethodName="GetDataByPhone" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPhone" UserSourceName="FillByPhone">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ADDRESS, AREA, ID, PERSONSCOUNT, PHONE, QQ, STATUS, USERNAME FROM PERSIONS WHERE (PHONE = ?) ORDER BY STATUS</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="PHONE" DataSourceName="PERSIONS" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="PHONE" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Web.config)" DbObjectName="PERSIONS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByQQ" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByQQ" GeneratorSourceName="FillByQQ" GetMethodModifier="Public" GetMethodName="GetDataByQQ" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByQQ" UserSourceName="FillByQQ">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ADDRESS, AREA, ID, PERSONSCOUNT, PHONE, QQ, STATUS, USERNAME FROM PERSIONS WHERE (QQ = ?) ORDER BY STATUS</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="QQ" DataSourceName="PERSIONS" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="QQ" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="QQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AREASTableAdapter" GeneratorDataComponentClassName="AREASTableAdapter" Name="AREAS" UserDataComponentName="AREASTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Web.config)" DbObjectName="AREAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `AREAS` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `AREAS` (`AREANAME`, `HOMEAREA`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AREANAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AREANAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="HOMEAREA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="HOMEAREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, AREANAME,HOMEAREA FROM AREAS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `AREAS` SET `AREANAME` = ?, `HOMEAREA` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AREANAME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AREANAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="HOMEAREA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="HOMEAREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="AREANAME" DataSetColumn="AREANAME" />
              <Mapping SourceColumn="HOMEAREA" DataSetColumn="HOMEAREA" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSetDB" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSetDB" msprop:Generator_UserDSName="DataSetDB">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="USERS" msprop:Generator_TableClassName="USERSDataTable" msprop:Generator_TableVarName="tableUSERS" msprop:Generator_TablePropName="USERS" msprop:Generator_RowDeletingName="USERSRowDeleting" msprop:Generator_UserTableName="USERS" msprop:Generator_RowChangingName="USERSRowChanging" msprop:Generator_RowEvHandlerName="USERSRowChangeEventHandler" msprop:Generator_RowDeletedName="USERSRowDeleted" msprop:Generator_RowEvArgName="USERSRowChangeEvent" msprop:Generator_RowChangedName="USERSRowChanged" msprop:Generator_RowClassName="USERSRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="LOGINNAME" msprop:Generator_ColumnVarNameInTable="columnLOGINNAME" msprop:Generator_ColumnPropNameInRow="LOGINNAME" msprop:Generator_ColumnPropNameInTable="LOGINNAMEColumn" msprop:Generator_UserColumnName="LOGINNAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LOGINPWD" msprop:Generator_ColumnVarNameInTable="columnLOGINPWD" msprop:Generator_ColumnPropNameInRow="LOGINPWD" msprop:Generator_ColumnPropNameInTable="LOGINPWDColumn" msprop:Generator_UserColumnName="LOGINPWD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="USERNAME" msprop:Generator_ColumnVarNameInTable="columnUSERNAME" msprop:Generator_ColumnPropNameInRow="USERNAME" msprop:Generator_ColumnPropNameInTable="USERNAMEColumn" msprop:Generator_UserColumnName="USERNAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AREA" msprop:Generator_ColumnVarNameInTable="columnAREA" msprop:Generator_ColumnPropNameInRow="AREA" msprop:Generator_ColumnPropNameInTable="AREAColumn" msprop:Generator_UserColumnName="AREA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PERSIONS" msprop:Generator_TableClassName="PERSIONSDataTable" msprop:Generator_TableVarName="tablePERSIONS" msprop:Generator_TablePropName="PERSIONS" msprop:Generator_RowDeletingName="PERSIONSRowDeleting" msprop:Generator_UserTableName="PERSIONS" msprop:Generator_RowChangingName="PERSIONSRowChanging" msprop:Generator_RowEvHandlerName="PERSIONSRowChangeEventHandler" msprop:Generator_RowDeletedName="PERSIONSRowDeleted" msprop:Generator_RowEvArgName="PERSIONSRowChangeEvent" msprop:Generator_RowChangedName="PERSIONSRowChanged" msprop:Generator_RowClassName="PERSIONSRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="USERNAME" msprop:Generator_ColumnVarNameInTable="columnUSERNAME" msprop:Generator_ColumnPropNameInRow="USERNAME" msprop:Generator_ColumnPropNameInTable="USERNAMEColumn" msprop:Generator_UserColumnName="USERNAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QQ" msprop:Generator_ColumnVarNameInTable="columnQQ" msprop:Generator_ColumnPropNameInRow="QQ" msprop:Generator_ColumnPropNameInTable="QQColumn" msprop:Generator_UserColumnName="QQ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PHONE" msprop:Generator_ColumnVarNameInTable="columnPHONE" msprop:Generator_ColumnPropNameInRow="PHONE" msprop:Generator_ColumnPropNameInTable="PHONEColumn" msprop:Generator_UserColumnName="PHONE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ADDRESS" msprop:Generator_ColumnVarNameInTable="columnADDRESS" msprop:Generator_ColumnPropNameInRow="ADDRESS" msprop:Generator_ColumnPropNameInTable="ADDRESSColumn" msprop:Generator_UserColumnName="ADDRESS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PERSONSCOUNT" msprop:Generator_ColumnVarNameInTable="columnPERSONSCOUNT" msprop:Generator_ColumnPropNameInRow="PERSONSCOUNT" msprop:Generator_ColumnPropNameInTable="PERSONSCOUNTColumn" msprop:Generator_UserColumnName="PERSONSCOUNT" type="xs:int" minOccurs="0" />
              <xs:element name="AREA" msprop:Generator_ColumnVarNameInTable="columnAREA" msprop:Generator_ColumnPropNameInRow="AREA" msprop:Generator_ColumnPropNameInTable="AREAColumn" msprop:Generator_UserColumnName="AREA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STATUS" msprop:Generator_ColumnVarNameInTable="columnSTATUS" msprop:Generator_ColumnPropNameInRow="STATUS" msprop:Generator_ColumnPropNameInTable="STATUSColumn" msprop:Generator_UserColumnName="STATUS" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AREAS" msprop:Generator_TableClassName="AREASDataTable" msprop:Generator_TableVarName="tableAREAS" msprop:Generator_TablePropName="AREAS" msprop:Generator_RowDeletingName="AREASRowDeleting" msprop:Generator_UserTableName="AREAS" msprop:Generator_RowChangingName="AREASRowChanging" msprop:Generator_RowEvHandlerName="AREASRowChangeEventHandler" msprop:Generator_RowDeletedName="AREASRowDeleted" msprop:Generator_RowEvArgName="AREASRowChangeEvent" msprop:Generator_RowChangedName="AREASRowChanged" msprop:Generator_RowClassName="AREASRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="AREANAME" msprop:Generator_ColumnVarNameInTable="columnAREANAME" msprop:Generator_ColumnPropNameInRow="AREANAME" msprop:Generator_ColumnPropNameInTable="AREANAMEColumn" msprop:Generator_UserColumnName="AREANAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HOMEAREA" msprop:Generator_ColumnVarNameInTable="columnHOMEAREA" msprop:Generator_ColumnPropNameInRow="HOMEAREA" msprop:Generator_ColumnPropNameInTable="HOMEAREAColumn" msprop:Generator_UserColumnName="HOMEAREA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:USERS" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="PERSIONS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PERSIONS" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="AREAS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AREAS" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>